use CreativeSystems;
GO

create PROC sp_getClientNames
AS
SELECT DISTINCT FirstName + ' ' + LastName "Client Name"
FROM Client
WHERE Client.IsActive = 1